Consumer Goods Industry
Introduction
My projects in consumer goods focus on managing product supply, improving quality, and understanding consumer trends. I help companies meet demand, enhance product appeal, and build strong customer loyalty.
Decoding Restaurant Ratings in Mexico
In this project, I analysed restaurant ratings in Mexico using PowerBI, based on a dataset featuring consumer reviews since 2012. The analysis revealed that single customers significantly influence ratings, while students are the largest demographic. Cuernavaca has the highest average ratings, and San Luis Potosi is a major dining hub.
Key findings include Restaurant Las Mananitas in Cuernavaca achieving top ratings, while other establishments face challenges. Recommendations emphasise a consumer-centric approach, exploring opportunities in regions with lower ratings, and focusing on consistent quality improvement to boost overall ratings.
Analysis of an Online Food Business Application
In this analysis of an online food business app, I explored customer engagement trends. The findings revealed that adults aged 35-63 have the highest campaign acceptance rates, indicating a need for targeted marketing. While the user base is primarily composed of adults (75%), there is potential for growth among younger users aged 24-34. Notably, wine and meat purchases drive significant sales, suggesting the business should expand these product offerings.
To enhance customer experience, it's crucial to improve the online shopping interface, emphasising intuitive navigation and personalised recommendations. Additional strategic recommendations include collaborating with local suppliers to attract eco-conscious consumers, leveraging social media for greater brand engagement, and utilising data-driven insights to optimise inventory and refine marketing strategies.